So we've been looking at print options and there's still a few more things that I want to fix here.
We are looking at that arrow which is causing that third page there it's the little bit of a smidge
of the tail end of that arrows leading into the third page which is otherwise blank.
And then I got my chart.
I'm cutting off that chart.
It's going in the page to where I really like to do is have my spreadsheet on page 1 and the chart all
by itself fully on page 2.
So let's take a look at how we can adjust this.
We've seen some options in print preview but I mean to take us into another view.
This is called The Page Layout view.
I mean the back arrow here to take me back to the main Excel interface I make up to my view tab top
of the screen and on the far left we've got our workbook views the most standard view the one that you're
going to spend most your time in and do all your work is called the normal view.
And that's what you're looking at right now.
It looks like Excel.
Well we've got a new one.
This was actually introduced in the 2010 edition of Excel called page layout and what page layout does
is it treats the document more like a Word document where you can actually see literally the pages.
But the nice thing here is you can still manipulate your data and the structure and the layout on individual
pages.
Watch this view view page layout.
So this changes my view and I zoom out so we can really see this here.
You can see that I've got individual pages there's page 1 there's Page 2 in that little little guy right
there.
Page 3.
So I need to fix that first.
I mean go fix that little arrow that will select my arrow here and I'm just going to pull that in.
I get that get that I think I might be grab up.
There we go.
All right good.
So I pulled that over.
We should no longer reprinting on that page there.
And how about my chart.
Now I want to put that all by itself.
So I'm just going to grab that and pull it down to this page here in one sense I can see what the page
actually looks like.
I'm going to center that right on the page.
There we go.
All right.
Now I'm still seeing this page here.
Let's go take a look and set of a print preview see if I'm still getting that third page.
I'm going to go back to file and print.
And let's see.
You know I got my charts selected still.
You notice that because I my charts like this only show me one page down here below.
So I got to go back out I mean a quick someplace empty just a dislike that chart.
And then I mean to go back to file back to print like get out.
I'm still getting that third page up.
There it is.
And they're just they're still just a little bit of a smidge of red inside there.
Let's go fix that and hit my back arrow.
Let's get back out here.
This might be just an artifact inside of myself.
Their egos had to shrink it up just a little bit more.
And that third page is no longer active.
All right.
Must be just too close to that that margin there.
So I've got two pages and just adjusting this all through the page layout view.
I don't have to worry about scaling.
I don't have to worry about trying to monkey around with the margins anymore.
Jump into page layout and make your adjustments there.
There are live adjustments.
We get to see what the literal document looks like as it's going to be printed on individual pages.
A very active very accessible environment.
So try this out.
Jump up to your view time go in the page layout adjust your document make it look good on the page when
you're done.
You can go right back to normal view back into just standard Excel.
So try this out.